/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : nocv

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 01/01/2023 17:07:24
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for approval_process
-- ----------------------------
DROP TABLE IF EXISTS `approval_process`;
CREATE TABLE `approval_process` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `day` int(11) DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `node_status` int(11) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of approval_process
-- ----------------------------
BEGIN;
INSERT INTO `approval_process` (`id`, `uid`, `reason`, `address`, `day`, `phone`, `node_status`, `create_time`, `update_time`) VALUES (1, 1, '疫情居家', '湖北襄阳', 2, '15827637955', 1, '2022-12-31 23:41:17', '2023-01-01 16:55:24');
INSERT INTO `approval_process` (`id`, `uid`, `reason`, `address`, `day`, `phone`, `node_status`, `create_time`, `update_time`) VALUES (2, 1, '回家', '湖北武汉', 1, '15827637955', 2, '2023-01-01 14:19:17', NULL);
INSERT INTO `approval_process` (`id`, `uid`, `reason`, `address`, `day`, `phone`, `node_status`, `create_time`, `update_time`) VALUES (3, 2, '上学', '武汉市汉阳区月湖街铁桥南村2号', 4, '15827637955', 0, '2023-01-01 14:20:52', NULL);
INSERT INTO `approval_process` (`id`, `uid`, `reason`, `address`, `day`, `phone`, `node_status`, `create_time`, `update_time`) VALUES (4, 1, '出差', '云南昆明', 4, '15827637955', 3, '2023-01-01 14:37:46', '2023-01-01 17:03:21');
INSERT INTO `approval_process` (`id`, `uid`, `reason`, `address`, `day`, `phone`, `node_status`, `create_time`, `update_time`) VALUES (5, 1, '过年', '湖北襄阳', 7, '15827637955', 4, '2023-01-01 14:44:36', NULL);
INSERT INTO `approval_process` (`id`, `uid`, `reason`, `address`, `day`, `phone`, `node_status`, `create_time`, `update_time`) VALUES (6, 1, '过年', '湖北黄石', 1, '15827637955', 5, '2023-01-01 14:47:48', NULL);
INSERT INTO `approval_process` (`id`, `uid`, `reason`, `address`, `day`, `phone`, `node_status`, `create_time`, `update_time`) VALUES (7, 1, '旅游', '北京', 365, '15827637955', 6, '2023-01-01 14:49:02', NULL);
COMMIT;

-- ----------------------------
-- Table structure for ban_ji
-- ----------------------------
DROP TABLE IF EXISTS `ban_ji`;
CREATE TABLE `ban_ji` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `xue_yuan_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of ban_ji
-- ----------------------------
BEGIN;
INSERT INTO `ban_ji` (`id`, `name`, `xue_yuan_id`) VALUES (1, '软件工程', 1);
INSERT INTO `ban_ji` (`id`, `name`, `xue_yuan_id`) VALUES (2, '计算机科学', 1);
COMMIT;

-- ----------------------------
-- Table structure for china_total
-- ----------------------------
DROP TABLE IF EXISTS `china_total`;
CREATE TABLE `china_total` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `confirm` int(255) DEFAULT NULL,
  `input` int(255) DEFAULT NULL,
  `severe` int(255) DEFAULT NULL,
  `heal` int(255) DEFAULT NULL,
  `dead` int(255) DEFAULT NULL,
  `suspect` int(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of china_total
-- ----------------------------
BEGIN;
INSERT INTO `china_total` (`id`, `confirm`, `input`, `severe`, `heal`, `dead`, `suspect`, `update_time`) VALUES (1, 9506895, 28824, 0, 468612, 31509, 0, '2022-12-26 20:25:55');
INSERT INTO `china_total` (`id`, `confirm`, `input`, `severe`, `heal`, `dead`, `suspect`, `update_time`) VALUES (2, 9506895, 28824, 0, 468612, 31509, 0, '2022-12-26 20:25:55');
INSERT INTO `china_total` (`id`, `confirm`, `input`, `severe`, `heal`, `dead`, `suspect`, `update_time`) VALUES (3, 9506895, 28824, 0, 468612, 31509, 0, '2022-12-27 08:26:09');
INSERT INTO `china_total` (`id`, `confirm`, `input`, `severe`, `heal`, `dead`, `suspect`, `update_time`) VALUES (4, 9506895, 28824, 0, 468612, 31509, 0, '2022-12-27 08:26:09');
INSERT INTO `china_total` (`id`, `confirm`, `input`, `severe`, `heal`, `dead`, `suspect`, `update_time`) VALUES (5, 9506895, 28824, 0, 468612, 31509, 0, '2022-12-27 08:26:09');
INSERT INTO `china_total` (`id`, `confirm`, `input`, `severe`, `heal`, `dead`, `suspect`, `update_time`) VALUES (6, 9506895, 28824, 0, 468612, 31509, 0, '2022-12-27 08:26:09');
INSERT INTO `china_total` (`id`, `confirm`, `input`, `severe`, `heal`, `dead`, `suspect`, `update_time`) VALUES (7, 9506895, 28824, 0, 468612, 31509, 0, '2022-12-27 08:26:09');
INSERT INTO `china_total` (`id`, `confirm`, `input`, `severe`, `heal`, `dead`, `suspect`, `update_time`) VALUES (8, 9506895, 28824, 0, 468612, 31509, 0, '2022-12-27 08:26:09');
INSERT INTO `china_total` (`id`, `confirm`, `input`, `severe`, `heal`, `dead`, `suspect`, `update_time`) VALUES (9, 9506895, 28824, 0, 468612, 31509, 0, '2022-12-27 08:26:09');
INSERT INTO `china_total` (`id`, `confirm`, `input`, `severe`, `heal`, `dead`, `suspect`, `update_time`) VALUES (10, 9506895, 28824, 0, 468612, 31509, 0, '2022-12-27 08:26:09');
INSERT INTO `china_total` (`id`, `confirm`, `input`, `severe`, `heal`, `dead`, `suspect`, `update_time`) VALUES (11, 9506895, 28824, 0, 468612, 31509, 0, '2022-12-28 00:00:39');
INSERT INTO `china_total` (`id`, `confirm`, `input`, `severe`, `heal`, `dead`, `suspect`, `update_time`) VALUES (12, 9506895, 28824, 0, 468612, 31509, 0, '2022-12-28 00:00:39');
INSERT INTO `china_total` (`id`, `confirm`, `input`, `severe`, `heal`, `dead`, `suspect`, `update_time`) VALUES (13, 9506895, 28824, 0, 468612, 31509, 0, '2022-12-28 00:00:39');
INSERT INTO `china_total` (`id`, `confirm`, `input`, `severe`, `heal`, `dead`, `suspect`, `update_time`) VALUES (14, 9506895, 28824, 0, 468612, 31509, 0, '2022-12-28 00:00:39');
INSERT INTO `china_total` (`id`, `confirm`, `input`, `severe`, `heal`, `dead`, `suspect`, `update_time`) VALUES (15, 9506895, 28824, 0, 468612, 31509, 0, '2022-12-28 00:00:39');
INSERT INTO `china_total` (`id`, `confirm`, `input`, `severe`, `heal`, `dead`, `suspect`, `update_time`) VALUES (16, 9506895, 28824, 0, 468612, 31509, 0, '2022-12-28 00:00:39');
COMMIT;

-- ----------------------------
-- Table structure for health_clock
-- ----------------------------
DROP TABLE IF EXISTS `health_clock`;
CREATE TABLE `health_clock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `morning_temp` varchar(255) DEFAULT NULL,
  `afternoon_temp` varchar(255) DEFAULT NULL,
  `night_temp` varchar(255) DEFAULT NULL,
  `fever_and_cough` varchar(255) DEFAULT NULL,
  `recent_home` varchar(255) DEFAULT NULL,
  `risk_zone` varchar(255) DEFAULT NULL,
  `recent_zone` varchar(255) DEFAULT NULL,
  `health_status` varchar(255) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of health_clock
-- ----------------------------
BEGIN;
INSERT INTO `health_clock` (`id`, `username`, `sex`, `age`, `phone`, `morning_temp`, `afternoon_temp`, `night_temp`, `fever_and_cough`, `recent_home`, `risk_zone`, `recent_zone`, `health_status`, `create_time`) VALUES (1, '9999', '男', 63, '18333603859', '36.5', '36.5', '36.5', '不发烧咳嗽', '西数', '高风险', '从西川到北京来玩', '健康', '2022-05-26 20:06:12');
INSERT INTO `health_clock` (`id`, `username`, `sex`, `age`, `phone`, `morning_temp`, `afternoon_temp`, `night_temp`, `fever_and_cough`, `recent_home`, `risk_zone`, `recent_zone`, `health_status`, `create_time`) VALUES (3, '曹阿瞒', '男', 65, '1833654', '36.5', '36.5', '36.5', '不发烧咳嗽', '北京', '低风险', '台湾 北京，峰态', '健康', '2022-05-26 20:06:50');
INSERT INTO `health_clock` (`id`, `username`, `sex`, `age`, `phone`, `morning_temp`, `afternoon_temp`, `night_temp`, `fever_and_cough`, `recent_home`, `risk_zone`, `recent_zone`, `health_status`, `create_time`) VALUES (4, '公共', '男', 36, '183336.3856', '36.5', '36.5', '36.5', '多分', '是的大幅度', '地方发的', '大幅度发到付', '健康', '2022-05-26 12:07:25');
INSERT INTO `health_clock` (`id`, `username`, `sex`, `age`, `phone`, `morning_temp`, `afternoon_temp`, `night_temp`, `fever_and_cough`, `recent_home`, `risk_zone`, `recent_zone`, `health_status`, `create_time`) VALUES (7, '李铭洋', '男', 20, '15827637955', '37.3', '37.2', '37.6', '不发烧咳嗽', '湖北襄阳', '低风险', '从湖北武汉到湖北襄阳', '健康', NULL);
COMMIT;

-- ----------------------------
-- Table structure for hesuan
-- ----------------------------
DROP TABLE IF EXISTS `hesuan`;
CREATE TABLE `hesuan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `card` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `result` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of hesuan
-- ----------------------------
BEGIN;
INSERT INTO `hesuan` (`id`, `name`, `age`, `phone`, `card`, `type`, `result`, `create_time`, `update_time`) VALUES (1, '李铭洋', 20, '15827637955', '420602200208021514', '混检', '阴性', '2022-12-31 11:34:20', '2022-12-31 11:34:40');
INSERT INTO `hesuan` (`id`, `name`, `age`, `phone`, `card`, `type`, `result`, `create_time`, `update_time`) VALUES (3, '李铭洋', 19, '15827637955', '420602200208021514', '单检', '阳性', '2022-12-31 11:35:10', '2022-12-31 11:35:40');
INSERT INTO `hesuan` (`id`, `name`, `age`, `phone`, `card`, `type`, `result`, `create_time`, `update_time`) VALUES (4, '李铭洋', 18, '15827637955', '420602200208021514', '咽式嗓子', '阳性', '2022-12-31 22:40:10', '2022-12-31 22:40:40');
COMMIT;

-- ----------------------------
-- Table structure for line_trend
-- ----------------------------
DROP TABLE IF EXISTS `line_trend`;
CREATE TABLE `line_trend` (
  `id` int(11) NOT NULL,
  `confirm` int(11) DEFAULT NULL,
  `isolation` int(11) DEFAULT NULL,
  `cure` int(11) DEFAULT NULL,
  `dead` int(11) DEFAULT NULL,
  `similar` int(11) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of line_trend
-- ----------------------------
BEGIN;
INSERT INTO `line_trend` (`id`, `confirm`, `isolation`, `cure`, `dead`, `similar`, `create_time`) VALUES (1, 786, 456, 79, 53, 123, '2022-12-17 12:06:20');
INSERT INTO `line_trend` (`id`, `confirm`, `isolation`, `cure`, `dead`, `similar`, `create_time`) VALUES (2, 1000, 563, 96, 78, 213, '2022-12-18 12:10:45');
INSERT INTO `line_trend` (`id`, `confirm`, `isolation`, `cure`, `dead`, `similar`, `create_time`) VALUES (3, 1200, 653, 115, 98, 312, '2022-12-19 12:10:45');
INSERT INTO `line_trend` (`id`, `confirm`, `isolation`, `cure`, `dead`, `similar`, `create_time`) VALUES (4, 1563, 759, 165, 110, 320, '2022-12-20 12:10:45');
INSERT INTO `line_trend` (`id`, `confirm`, `isolation`, `cure`, `dead`, `similar`, `create_time`) VALUES (5, 1789, 865, 220, 210, 365, '2022-12-21 12:10:45');
INSERT INTO `line_trend` (`id`, `confirm`, `isolation`, `cure`, `dead`, `similar`, `create_time`) VALUES (6, 2134, 987, 276, 256, 400, '2022-12-22 12:10:45');
INSERT INTO `line_trend` (`id`, `confirm`, `isolation`, `cure`, `dead`, `similar`, `create_time`) VALUES (7, 2563, 1100, 350, 320, 457, '2022-12-23 12:10:45');
COMMIT;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) DEFAULT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `premission` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `href` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `open` int(255) DEFAULT NULL,
  `ordernum` int(11) DEFAULT NULL,
  `available` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (1, 0, 'menu', '疫情数据可视化', NULL, '&#xe629', '', 0, 1, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (2, 1, 'menu', '中国疫情地图', NULL, '&#xe629', '/toChina', 0, 2, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (3, 1, 'menu', '疫情饼图', NULL, '&#xe629', '/toPie', 0, 3, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (4, 1, 'menu', '疫情柱状图', NULL, '&#xe629', '/toBar', 0, 4, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (5, 1, 'menu', '疫情折线图', NULL, '&#xe629', '/toLine', 0, 5, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (6, 1, 'menu', '全球疫情地图', NULL, '&#xe629', '/toGlobal', 0, 6, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (7, 0, 'menu', '疫情数据管理', NULL, '&#xe637;', NULL, 0, 7, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (8, 7, 'menu', '中国疫情数据管理', NULL, '&#xe637;', '/toChinaManager', 0, 8, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (9, 0, 'menu', '校园防疫管理', NULL, '&#xe679;', '', 0, 9, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (10, 9, 'menu', '健康打卡记录', NULL, '&#xe679;', '/toHealthClock', 0, 10, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (11, 0, 'menu', '系统管理', NULL, '&#xe620;', NULL, 1, 11, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (12, 11, 'menu', '菜单管理', NULL, '&#xe649;', '/menu/toMenu', 0, 12, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (17, 7, 'menu', '疫情新闻管理', NULL, '&#xe7ae;', '/news/toNews', 1, 15, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (16, 11, 'menu', '用户管理', NULL, '&#xe612;', '/user/toUser', 1, 14, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (15, 11, 'menu', '角色管理', NULL, '&#xe612;', '/role/toRole', 1, 13, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (18, 0, 'menu', '校园系统管理', NULL, '&#xe66c;', NULL, 0, 16, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (20, 18, 'menu', '学院管理', NULL, '&#xe62e;', '/xueyuan/toXueYuan', 1, 17, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (21, 18, 'menu', '班级管理', NULL, '&#xe62b;', '/banji/toBanJi', 1, 18, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (22, 9, 'menu', '核酸检测管理', NULL, '&#xe62a;', '/hesuan/toHeSuan', 1, 19, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (23, 9, 'menu', '疫苗接种管理', NULL, '&#xe6b1;', '/vaccine/toVaccine', 1, 20, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (24, 1, 'menu', '全国新增趋势图', NULL, '&#xe62c', '/trend/toIncrease', 1, 21, 1);
INSERT INTO `menu` (`id`, `pid`, `type`, `title`, `premission`, `icon`, `href`, `open`, `ordernum`, `available`) VALUES (25, 18, 'menu', '请假审批管理', NULL, '&#xe62d;', '/approval/toApproval', 1, 22, 1);
COMMIT;

-- ----------------------------
-- Table structure for nocv_data
-- ----------------------------
DROP TABLE IF EXISTS `nocv_data`;
CREATE TABLE `nocv_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` int(11) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=273 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of nocv_data
-- ----------------------------
BEGIN;
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (1, '台湾', 8624681, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (2, '香港', 491154, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (3, '湖北', 68861, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (4, '上海', 65423, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (5, '广东', 63739, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (6, '吉林', 40485, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (7, '北京', 28860, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (8, '四川', 12023, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (9, '海南', 10436, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (10, '重庆', 10181, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (11, '河南', 9089, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (12, '内蒙古', 8394, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (13, '福建', 7651, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (14, '浙江', 6235, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (15, '陕西', 5589, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (16, '云南', 5561, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (17, '黑龙江', 5493, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (18, '山西', 5142, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (19, '山东', 4797, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (20, '江苏', 3808, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (21, '辽宁', 3086, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (22, '湖南', 2983, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (23, '河北', 2943, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (24, '天津', 2913, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (25, '新疆', 2632, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (26, '广西', 2457, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (27, '江西', 1971, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (28, '贵州', 1794, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (29, '安徽', 1700, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (30, '澳门', 1569, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (31, '甘肃', 1563, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (32, '西藏', 1515, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (33, '青海', 542, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (34, '宁夏', 239, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (35, '台湾', 8624680, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (36, '香港', 491154, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (37, '湖北', 68861, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (38, '上海', 65423, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (39, '广东', 63739, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (40, '吉林', 40485, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (41, '北京', 28860, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (42, '四川', 12023, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (43, '海南', 10436, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (44, '重庆', 10181, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (45, '河南', 9089, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (46, '内蒙古', 8394, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (47, '福建', 7651, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (48, '浙江', 6235, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (49, '陕西', 5589, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (50, '云南', 5561, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (51, '黑龙江', 5493, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (52, '山西', 5142, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (53, '山东', 4797, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (54, '江苏', 3808, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (55, '辽宁', 3086, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (56, '湖南', 2983, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (57, '河北', 2943, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (58, '天津', 2913, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (59, '新疆', 2632, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (60, '广西', 2457, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (61, '江西', 1971, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (62, '贵州', 1794, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (63, '安徽', 1700, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (64, '澳门', 1569, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (65, '甘肃', 1563, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (66, '西藏', 1515, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (67, '青海', 542, '2022-12-27 00:00:48');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (68, '宁夏', 239, '2022-12-27 00:00:49');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (69, '台湾', 8582141, '2022-12-28 00:00:36');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (70, '香港', 373002, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (71, '湖北', 216, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (72, '上海', 604, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (73, '广东', 10705, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (74, '吉林', 47, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (75, '北京', 11326, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (76, '四川', 1664, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (77, '海南', 1292, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (78, '重庆', 2694, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (79, '河南', 2186, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (80, '内蒙古', 60, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (81, '福建', 838, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (82, '浙江', 1383, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (83, '陕西', 475, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (84, '云南', 1455, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (85, '黑龙江', 227, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (86, '山西', 803, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (87, '山东', 271, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (88, '江苏', 13, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (89, '辽宁', 276, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (90, '湖南', 917, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (91, '河北', -1658, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (92, '天津', 421, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (93, '新疆', 23, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (94, '广西', 51, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (95, '江西', 437, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (96, '贵州', 6, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (97, '安徽', 29, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (98, '澳门', 441, '2022-12-28 00:00:36');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (99, '甘肃', 12, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (100, '西藏', 0, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (101, '青海', 50, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (102, '宁夏', 14, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (103, '台湾', 8582141, '2022-12-28 00:00:36');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (104, '香港', 373002, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (105, '湖北', 216, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (106, '上海', 604, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (107, '广东', 10705, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (108, '吉林', 47, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (109, '北京', 11326, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (110, '四川', 1664, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (111, '海南', 1292, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (112, '重庆', 2694, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (113, '河南', 2186, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (114, '内蒙古', 60, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (115, '福建', 838, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (116, '浙江', 1383, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (117, '陕西', 475, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (118, '云南', 1455, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (119, '黑龙江', 227, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (120, '山西', 803, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (121, '山东', 271, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (122, '江苏', 13, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (123, '辽宁', 276, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (124, '湖南', 917, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (125, '河北', -1658, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (126, '天津', 421, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (127, '新疆', 23, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (128, '广西', 51, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (129, '江西', 437, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (130, '贵州', 6, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (131, '安徽', 29, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (132, '澳门', 441, '2022-12-28 00:00:36');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (133, '甘肃', 12, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (134, '西藏', 0, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (135, '青海', 50, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (136, '宁夏', 14, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (137, '台湾', 8582141, '2022-12-28 00:00:36');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (138, '香港', 373002, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (139, '湖北', 216, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (140, '上海', 604, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (141, '广东', 10705, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (142, '吉林', 47, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (143, '北京', 11326, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (144, '四川', 1664, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (145, '海南', 1292, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (146, '重庆', 2694, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (147, '河南', 2186, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (148, '内蒙古', 60, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (149, '福建', 838, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (150, '浙江', 1383, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (151, '陕西', 475, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (152, '云南', 1455, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (153, '黑龙江', 227, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (154, '山西', 803, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (155, '山东', 271, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (156, '江苏', 13, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (157, '辽宁', 276, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (158, '湖南', 917, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (159, '河北', -1658, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (160, '天津', 421, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (161, '新疆', 23, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (162, '广西', 51, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (163, '江西', 437, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (164, '贵州', 6, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (165, '安徽', 29, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (166, '澳门', 441, '2022-12-28 00:00:36');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (167, '甘肃', 12, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (168, '西藏', 0, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (169, '青海', 50, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (170, '宁夏', 14, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (172, '香港', 373002, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (173, '湖北', 216, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (174, '上海', 604, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (175, '广东', 10705, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (176, '吉林', 47, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (177, '北京', 11326, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (178, '四川', 1664, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (179, '海南', 1292, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (180, '重庆', 2694, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (181, '河南', 2186, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (182, '内蒙古', 60, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (183, '福建', 838, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (184, '浙江', 1383, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (185, '陕西', 475, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (186, '云南', 1455, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (187, '黑龙江', 227, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (188, '山西', 803, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (189, '山东', 271, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (190, '江苏', 13, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (191, '辽宁', 276, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (192, '湖南', 917, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (193, '河北', -1658, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (194, '天津', 421, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (195, '新疆', 23, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (196, '广西', 51, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (197, '江西', 437, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (198, '贵州', 6, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (199, '安徽', 29, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (200, '澳门', 441, '2022-12-28 00:00:36');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (201, '甘肃', 12, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (202, '西藏', 0, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (203, '青海', 50, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (204, '宁夏', 14, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (205, '台湾', 8582141, '2022-12-28 00:00:36');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (206, '香港', 373002, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (207, '湖北', 216, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (208, '上海', 604, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (209, '广东', 10705, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (210, '吉林', 47, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (211, '北京', 11326, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (212, '四川', 1664, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (213, '海南', 1292, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (214, '重庆', 2694, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (215, '河南', 2186, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (216, '内蒙古', 60, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (217, '福建', 838, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (218, '浙江', 1383, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (219, '陕西', 475, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (220, '云南', 1455, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (221, '黑龙江', 227, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (222, '山西', 803, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (223, '山东', 271, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (224, '江苏', 13, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (225, '辽宁', 276, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (226, '湖南', 917, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (227, '河北', -1658, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (228, '天津', 421, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (229, '新疆', 23, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (230, '广西', 51, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (231, '江西', 437, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (232, '贵州', 6, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (233, '安徽', 29, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (234, '澳门', 441, '2022-12-28 00:00:36');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (235, '甘肃', 12, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (236, '西藏', 0, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (237, '青海', 50, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (238, '宁夏', 14, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (239, '台湾', 8582141, '2022-12-28 00:00:36');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (240, '香港', 373002, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (241, '湖北', 216, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (242, '上海', 604, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (243, '广东', 10705, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (244, '吉林', 47, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (245, '北京', 11326, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (246, '四川', 1664, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (247, '海南', 1292, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (248, '重庆', 2694, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (249, '河南', 2186, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (250, '内蒙古', 60, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (251, '福建', 838, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (252, '浙江', 1383, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (253, '陕西', 475, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (254, '云南', 1455, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (255, '黑龙江', 227, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (256, '山西', 803, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (257, '山东', 271, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (258, '江苏', 13, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (259, '辽宁', 276, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (260, '湖南', 917, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (261, '河北', -1658, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (262, '天津', 421, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (263, '新疆', 23, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (264, '广西', 51, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (265, '江西', 437, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (266, '贵州', 6, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (267, '安徽', 29, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (268, '澳门', 441, '2022-12-28 00:00:36');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (269, '甘肃', 12, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (270, '西藏', 0, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (271, '青海', 50, '2022-12-28 00:00:30');
INSERT INTO `nocv_data` (`id`, `name`, `value`, `update_time`) VALUES (272, '宁夏', 14, '2022-12-28 00:00:30');
COMMIT;

-- ----------------------------
-- Table structure for nocv_global_data
-- ----------------------------
DROP TABLE IF EXISTS `nocv_global_data`;
CREATE TABLE `nocv_global_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `value` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of nocv_global_data
-- ----------------------------
BEGIN;
INSERT INTO `nocv_global_data` (`id`, `name`, `value`) VALUES (1, 'United States', 2055555);
INSERT INTO `nocv_global_data` (`id`, `name`, `value`) VALUES (2, 'China', 88888);
INSERT INTO `nocv_global_data` (`id`, `name`, `value`) VALUES (3, 'Brazil', 691750008);
INSERT INTO `nocv_global_data` (`id`, `name`, `value`) VALUES (4, 'Russia', 10000000);
INSERT INTO `nocv_global_data` (`id`, `name`, `value`) VALUES (5, 'United Kingdom', 5000000);
INSERT INTO `nocv_global_data` (`id`, `name`, `value`) VALUES (6, 'Spain', 653256);
INSERT INTO `nocv_global_data` (`id`, `name`, `value`) VALUES (7, 'France', 195686);
INSERT INTO `nocv_global_data` (`id`, `name`, `value`) VALUES (8, 'Germany', 1568956);
INSERT INTO `nocv_global_data` (`id`, `name`, `value`) VALUES (9, 'Canada', 1000000);
INSERT INTO `nocv_global_data` (`id`, `name`, `value`) VALUES (10, 'Australia', 2000000);
INSERT INTO `nocv_global_data` (`id`, `name`, `value`) VALUES (11, 'Japan', 8000000);
INSERT INTO `nocv_global_data` (`id`, `name`, `value`) VALUES (12, 'Sudan', 9000000);
COMMIT;

-- ----------------------------
-- Table structure for nocv_news
-- ----------------------------
DROP TABLE IF EXISTS `nocv_news`;
CREATE TABLE `nocv_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `publishby` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of nocv_news
-- ----------------------------
BEGIN;
INSERT INTO `nocv_news` (`id`, `title`, `content`, `create_time`, `publishby`) VALUES (1, '基础', 'JavaSe,mysql,jdbc,javaweb,spring,springmvc,springboot', '2022-12-30 16:55:53', '大一上的李铭洋');
INSERT INTO `nocv_news` (`id`, `title`, `content`, `create_time`, `publishby`) VALUES (2, '项目', 'ssm,springboot+vue,springcloud', '2022-12-30 16:56:42', '大一下的李铭洋');
INSERT INTO `nocv_news` (`id`, `title`, `content`, `create_time`, `publishby`) VALUES (3, '进阶', '实战项目 自我创新 ', '2022-12-30 16:57:31', '大二上的李铭洋');
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `remark` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` (`id`, `name`, `remark`) VALUES (1, '管理员', '拥有所有的权限');
INSERT INTO `role` (`id`, `name`, `remark`) VALUES (2, '教师', '拥有增删改查');
INSERT INTO `role` (`id`, `name`, `remark`) VALUES (3, '学生', '拥有查询');
INSERT INTO `role` (`id`, `name`, `remark`) VALUES (4, '院系', '拥有所有人的权限,可以增加删除和修改,操作菜单');
COMMIT;

-- ----------------------------
-- Table structure for role_menu
-- ----------------------------
DROP TABLE IF EXISTS `role_menu`;
CREATE TABLE `role_menu` (
  `rid` int(11) DEFAULT NULL,
  `mid` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of role_menu
-- ----------------------------
BEGIN;
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (3, 6);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (3, 5);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (3, 4);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (3, 3);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (1, 16);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (1, 12);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (1, 11);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (1, 10);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (1, 9);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (1, 17);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (1, 8);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (1, 7);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (1, 6);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (3, 2);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (3, 1);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (1, 5);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (1, 4);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (1, 3);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (1, 2);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (1, 1);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (1, 15);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (3, 18);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (3, 25);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 1);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 2);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 3);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 4);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 5);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 6);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 24);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 7);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 8);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 17);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 9);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 10);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 22);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 23);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 11);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 12);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 16);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 15);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 18);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 20);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 21);
INSERT INTO `role_menu` (`rid`, `mid`) VALUES (4, 25);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `salt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sex` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `card` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ban_ji_id` int(11) DEFAULT NULL,
  `xue_yuan_id` int(11) DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_ibfk_2` (`ban_ji_id`),
  KEY `user_ibfk_3` (`xue_yuan_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `sex`, `age`, `address`, `img`, `phone`, `card`, `ban_ji_id`, `xue_yuan_id`, `teacher_id`) VALUES (1, 'admin', '123', NULL, '男', 19, '湖北襄阳', '/images/login.jpg', '15827637955', '420602200208021514', 1, 1, 1);
INSERT INTO `user` (`id`, `username`, `password`, `salt`, `sex`, `age`, `address`, `img`, `phone`, `card`, `ban_ji_id`, `xue_yuan_id`, `teacher_id`) VALUES (2, 'cxyxm', '123456', NULL, '男', 20, '湖北武汉', '/images/login.jpg', '15827637955', '420602200208021514', 1, 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
  `uid` int(11) DEFAULT NULL,
  `rid` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of user_role
-- ----------------------------
BEGIN;
INSERT INTO `user_role` (`uid`, `rid`) VALUES (2, 3);
INSERT INTO `user_role` (`uid`, `rid`) VALUES (1, 1);
COMMIT;

-- ----------------------------
-- Table structure for vaccine
-- ----------------------------
DROP TABLE IF EXISTS `vaccine`;
CREATE TABLE `vaccine` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `card` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zhenci` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pici` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `changjia` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `danwei` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of vaccine
-- ----------------------------
BEGIN;
INSERT INTO `vaccine` (`id`, `name`, `age`, `phone`, `card`, `zhenci`, `pici`, `changjia`, `danwei`, `create_time`) VALUES (1, '李铭洋', 20, '15827637955', '420602200208021514', '一针', 'AFASFASFDAS', '北京科兴', '中国制药集团', '2022-12-31 12:01:30');
COMMIT;

-- ----------------------------
-- Table structure for xue_yuan
-- ----------------------------
DROP TABLE IF EXISTS `xue_yuan`;
CREATE TABLE `xue_yuan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of xue_yuan
-- ----------------------------
BEGIN;
INSERT INTO `xue_yuan` (`id`, `name`) VALUES (1, '计算机信息技术学院');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
